Tabela CostAccount

Definicja tabeli CostAccount

Name

CostAccount

Code

CostAccount

Comment

Osrodek kosztów ("piatka")


Lista kolumn tabeli CostAccount

Name

Code

CostAccountID

CostAccountID

OrgUnitTypeID

OrgUnitTypeID

CostAccountGroupID

CostAccountGroupID

AccountNo

AccountNo

CostKindID

CostKindID

FullName

FullName

Description

Description

Comments

Comments

StartDT

StartDT

StopDT

StopDT

Active

Active

TransferCost

TransferCost

Servicer

Servicer

IgnoreHISStats

IgnoreHISStats

ReceiveManagementCost

ReceiveManagementCost

ImportFKCost

ImportFKCost


Kolumna CostAccountID tabeli CostAccount

Definicja kolumny CostAccountID tabeli CostAccount

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna OrgUnitTypeID tabeli CostAccount

Definicja kolumny OrgUnitTypeID tabeli CostAccount

Name

OrgUnitTypeID

Code

OrgUnitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CostAccountGroupID tabeli CostAccount

Definicja kolumny CostAccountGroupID tabeli CostAccount

Name

CostAccountGroupID

Code

CostAccountGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID grupy osrodków kosztów


Kolumna AccountNo tabeli CostAccount

Definicja kolumny AccountNo tabeli CostAccount

Name

AccountNo

Code

AccountNo

Data Type

VARCHAR2(48)

Mandatory

No

Comment

Numer konta


Kolumna CostKindID tabeli CostAccount

Definicja kolumny CostKindID tabeli CostAccount

Name

CostKindID

Code

CostKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

skladnik kosztów leczenia pacjenta


Kolumna FullName tabeli CostAccount

Definicja kolumny FullName tabeli CostAccount

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Nazwa konta


Kolumna Description tabeli CostAccount

Definicja kolumny Description tabeli CostAccount

Name

Description

Code

Description

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Opis konta


Kolumna Comments tabeli CostAccount

Definicja kolumny Comments tabeli CostAccount

Name

Comments

Code

Comments

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna StartDT tabeli CostAccount

Definicja kolumny StartDT tabeli CostAccount

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli CostAccount

Definicja kolumny StopDT tabeli CostAccount

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli CostAccount

Definicja kolumny Active tabeli CostAccount

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna TransferCost tabeli CostAccount

Definicja kolumny TransferCost tabeli CostAccount

Name

TransferCost

Code

TransferCost

Data Type

NUMBER(5)

Mandatory

No

Comment

przekazuje koszty


Kolumna Servicer tabeli CostAccount

Definicja kolumny Servicer tabeli CostAccount

Name

Servicer

Code

Servicer

Data Type

NUMBER(5)

Mandatory

No

Comment

wykonuje uslugi medyczne


Kolumna IgnoreHISStats tabeli CostAccount

Definicja kolumny IgnoreHISStats tabeli CostAccount

Name

IgnoreHISStats

Code

IgnoreHISStats

Data Type

NUMBER(5)

Mandatory

No

Comment

ignoruje wykonania z systemu szpitalnego


Kolumna ReceiveManagementCost tabeli CostAccount

Definicja kolumny ReceiveManagementCost tabeli CostAccount

Name

ReceiveManagementCost

Code

ReceiveManagementCost

Data Type

NUMBER(5)

Mandatory

No

Comment

otrzymuje koszty zarzadu


Kolumna ImportFKCost tabeli CostAccount

Definicja kolumny ImportFKCost tabeli CostAccount

Name

ImportFKCost

Code

ImportFKCost

Data Type

NUMBER(5)

Mandatory

No

Comment

importuje koszty z systemu FK


Lista kluczy tabeli CostAccount

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli CostAccount

Definicja klucza Identifier_1 tabeli CostAccount

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment